/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Version : 50542
 Source Host           : localhost
 Source Database       : kfsy_channel_store

 Target Server Version : 50542
 File Encoding         : utf-8

 Date: 09/29/2017 09:41:58 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `kf_channel_category`
-- ----------------------------
DROP TABLE IF EXISTS `kf_channel_category`;
CREATE TABLE `kf_channel_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fk_channel_id` int(11) NOT NULL DEFAULT '0' COMMENT '第三方渠道id',
  `fk_store_id` int(11) NOT NULL DEFAULT '0' COMMENT '快方药店id',
  `fk_category_id` int(11) NOT NULL DEFAULT '0' COMMENT '快方分类id',
  `other_category_id` varchar(50) NOT NULL DEFAULT '0' COMMENT '第三方分类id',
  `other_category_name` varchar(50) NOT NULL DEFAULT '' COMMENT '第三方分类名称',
  `other_category_rank` int(11) NOT NULL DEFAULT '0' COMMENT '第三方分类排序',
  `createtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '数据创建时间',
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '数据最后更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `store_channel_id` (`fk_channel_id`,`fk_store_id`,`fk_category_id`) USING BTREE,
  KEY `store_id` (`fk_store_id`),
  KEY `category_id` (`fk_category_id`),
  KEY `other_category_id` (`other_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `kf_channel_category`
-- ----------------------------
BEGIN;
INSERT INTO `kf_channel_category` VALUES ('3', '2', '3', '911', '150657097435130', '急救灵2', '52', '2017-09-28 10:54:17', '2017-09-28 13:10:13'), ('5', '2', '3', '912', '150657102035157', '感冒灵', '99', '2017-09-28 11:57:00', '2017-09-28 11:59:51'), ('6', '2', '3', '913', '150657104835158', '流感', '99', '2017-09-28 11:57:28', '2017-09-28 11:59:29');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
